<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, database.*" %>
<jsp:useBean id="con" class="database.DatabaseConnection"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Data List of Rim </title>
<style type="text/css">
<!--
body {
	background-image: url(../../image/3110_background/backcolor3.jpg);
}
-->
</style></head>

<body>
<form>
  <table width="447" border="1" align="center">
    <tr>
      <td colspan="6" align="center" valign="middle">Data List of Rim </td>
    </tr>
    <tr>
      <td width="65" align="center" valign="middle" nowrap="nowrap">ID</td>
      <td width="69" align="center" valign="middle" nowrap="nowrap">Tire Width</td>
      <td width="86" align="center" valign="middle" nowrap="nowrap">Aspect Ratio</td>
      <td width="91" align="center" valign="middle" nowrap="nowrap">Rim Diameter</td>
      <td colspan="2" align="center" valign="middle" nowrap="nowrap">Action</td>
    </tr>
    <%
        con.createConnection();
        ResultSet rs = con.getManu();
        String Rim_ID = null;
        String Tire_Width = null;
        String Aspect_Ratio = null;
		String Rim_Diameter = null;

                    for (int j = 0; j < 8; j++) {
                        if (rs.next()) {
                            Rim_ID = rs.getString("Rim_ID");
                            Tire_Width = rs.getString("Tire_Width");
                            Aspect_Ratio = rs.getString("Aspect_Ratio");
							Rim_Diameter = rs.getString("Rim_Diameter");
                    %>
                    <tr align="left" valign="top">
                    <td align="center" valign="middle"><%=Rim_ID%></td>
                    <td align="center" valign="middle"><%=Tire_Width%></td>
                    <td align="center" valign="middle"><%=Aspect_Ratio%></td>
                    <td align="center" valign="middle"><%=Rim_Diameter%></td>
                    <td colspan="2" align="center" valign="middle"><a href="" target="mainFrame">Delete</a></td>
                    </tr>
                    <%
                        }
                    }
                    %>
                <tr>
                    <td colspan="3" align="center" valign="middle">&nbsp;</td>
                    <td width="56" align="center" valign="middle">Back</td>
                    <td width="58" align="center" valign="middle">Next</td>
                </tr>
            </table>
            <p>&nbsp;</p>
        </form>
      </body>
   </html>